UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J3BrJG7AufbOgerNCdA0Lu3NYvfljVigB0ygJd9hACI='
WHERE
key_id = '1adea1ffd9ada4cd9508b724502949475a45a0381ac61d959ca022dd77fe9167'
AND (
token = 'J3BrJG7AufbOgerNCdA0Lu3NYvfljVigB0ygJd9hACI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)