UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qE6LbrBJcUdCs5N78zgwxUFMa3dCrsdiYVuFl+KGmQE='
WHERE
key_id = 'a2704e150a13e4558103cd1e766a08a53f73de84139362f7a75c8545432a35c9'
AND (
token = 'qE6LbrBJcUdCs5N78zgwxUFMa3dCrsdiYVuFl+KGmQE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)