UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VB4AKFPtyqJfZ6qxLjWn+pyDtv0loTeReqP1L55eZug='
WHERE
key_id = 'a4ee36893e55c4988a4ef24dbcaa5c90b6d33c1c468bb3c680a29ad3883aa592'
AND (
token = 'VB4AKFPtyqJfZ6qxLjWn+pyDtv0loTeReqP1L55eZug='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)