UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xj+8/jm+GcHKMkousZ+t1ahgKypOYaRlK1CmW9LHDZA='
WHERE
key_id = 'e9e86f287362661f342040ae63d91c780737d8f68b8b4edae691f48bce16c7bc'
AND (
token = 'xj+8/jm+GcHKMkousZ+t1ahgKypOYaRlK1CmW9LHDZA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)