UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a0BxBAMJbL1trkpPbgcVTrocj1Si1VaZNHjkHUWjCkE='
WHERE
key_id = '6c0e26c11b25560597fea970c984a808adb333a41758577750277dd3c97e765a'
AND (
token = 'a0BxBAMJbL1trkpPbgcVTrocj1Si1VaZNHjkHUWjCkE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)