UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wE8eUlPGIpOJ3ti0RV16slTXoVYlrX0fNwmSlHbu4CU='
WHERE
key_id = 'dcce3673c51a4e1abd8c0e9d4f264d4bc10304f56e0988afc213bb7ae4ae37a1'
AND (
token = 'wE8eUlPGIpOJ3ti0RV16slTXoVYlrX0fNwmSlHbu4CU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)