UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7MpSFhkrYzF1JSZVOe7rUTJEnpsziKp1QPqbbFEH8/8='
WHERE
key_id = 'd55d2ae8cef6716f0fd385dbee8fdf0629ed78fb3162e9250e0657dde27c3b93'
AND (
token = '7MpSFhkrYzF1JSZVOe7rUTJEnpsziKp1QPqbbFEH8/8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)