UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BnRccVvA/FnSN7V5s/JJhhB2j/0Gj23++3qZWqLxCLU='
WHERE
key_id = '408afec77b7ca43b8be5d2b6e7c7f1483c4b57365c8be919e20982bd687bd77b'
AND (
token = 'BnRccVvA/FnSN7V5s/JJhhB2j/0Gj23++3qZWqLxCLU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)