UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RHaLMPn5E2dZ0uTGzUd3dYvYnlezwSDLRLrHPzru+NU='
WHERE
key_id = 'd530877c6fe5574419874b9709a1e431e1b38d910f91e14dd2765090536a4ac9'
AND (
token = 'RHaLMPn5E2dZ0uTGzUd3dYvYnlezwSDLRLrHPzru+NU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)