UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NE0H5vqoX2WTFF2PHZWjAWt5qC7rRNOYBkNtCNP24R8='
WHERE
key_id = '4d4c02cab028686d8bb60dcf9f6a8ca10d47796c24fb795a8027ecf4c19cff44'
AND (
token = 'NE0H5vqoX2WTFF2PHZWjAWt5qC7rRNOYBkNtCNP24R8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)