UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YEZ4VavJFUz52js9kjKVi5cIOjDBf06vNNxzQgjS3/M='
WHERE
key_id = 'cabfd6f5872f02733b2ed5cfedabe920d74b372e7a3de290b4cffb06defcd5a5'
AND (
token = 'YEZ4VavJFUz52js9kjKVi5cIOjDBf06vNNxzQgjS3/M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)