UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hfQOCfby7fd78ObJonTs3BiBTRx1C26sJ/mGLX+GuJw='
WHERE
key_id = 'e165adee8d58543d980bff1a22c34dd2d02ee4984ce099a88ef634d018f2000a'
AND (
token = 'hfQOCfby7fd78ObJonTs3BiBTRx1C26sJ/mGLX+GuJw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)