UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '95aEFf7EYZPFL171rZVAasRhAl+s5PcKEZ+jULyM5IQ='
WHERE
key_id = '512a7fdc3ac8cb534ab506c2a09022d14d47efee846aa1a0004d426b760045b6'
AND (
token = '95aEFf7EYZPFL171rZVAasRhAl+s5PcKEZ+jULyM5IQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)