UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CtbBFPmWTGW9dNpWN1wsHITT+eifgnG8QuqbcqmZKe0='
WHERE
key_id = 'a2ad514fadf5afc3882a01bae10a9f330b20bda80a0280b586d21ff84a20784b'
AND (
token = 'CtbBFPmWTGW9dNpWN1wsHITT+eifgnG8QuqbcqmZKe0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)