UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a3lW6mytNhtJrYtWmW11Xy6evE/aVbcWlv9oo/7YY5Y='
WHERE
key_id = '9d202194d92b4b7a1731880c21487dc03cc5743dc6c9383f87c5d86e3e92d7ec'
AND (
token = 'a3lW6mytNhtJrYtWmW11Xy6evE/aVbcWlv9oo/7YY5Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)