UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zmh7NT4C6nmjjxKMYxEtMibhaEnm89I7LwBcgsfh0Fo='
WHERE
key_id = '9e4619e0d1160e362ecdab88fa34f12eb20de0a849b00bcf1a374058a64ce544'
AND (
token = 'Zmh7NT4C6nmjjxKMYxEtMibhaEnm89I7LwBcgsfh0Fo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)