UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pSQa9I86dh6Ejw3Y+nBvlIFAz+lyvADMiNVtmF3m+dk='
WHERE
key_id = 'a8c8221c5834bcc8c7b74e533572980f82621e726cd33b101a64d406f1c3dece'
AND (
token = 'pSQa9I86dh6Ejw3Y+nBvlIFAz+lyvADMiNVtmF3m+dk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)