UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BJcrQT2DLd/7hj0Kdh9Ma7HyP8cy+JxpdMUvdMscogs='
WHERE
key_id = 'c12ec8e1a5aa49523b8e44edd5b89d23311ec6efe06a2172061cddb9ce449787'
AND (
token = 'BJcrQT2DLd/7hj0Kdh9Ma7HyP8cy+JxpdMUvdMscogs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)