UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BeU/D8ykmCV0DccD4lKAtR+gnanWJF2pAWoT45JDnLU='
WHERE
key_id = 'e2c7c2e062ece39f18e91dadeccd96e932055498066cc508c4e6349b26607906'
AND (
token = 'BeU/D8ykmCV0DccD4lKAtR+gnanWJF2pAWoT45JDnLU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)