UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'F605lyXYEvtAFI6KUDs5twi6fGNX3gd5YhHXsoS0ADM='
WHERE
key_id = 'b5985824f08b15d00261ec18ea3f529685183d32f0117d138eea66feceaefec4'
AND (
token = 'F605lyXYEvtAFI6KUDs5twi6fGNX3gd5YhHXsoS0ADM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)