UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xbYu++29tUGLfVBzMIhe8AF7AS7grdrgs2lli0WMmN4='
WHERE
key_id = '7c4802d094cd6ca080aa00814857c3198851bc01be26561df30538afeefa137e'
AND (
token = 'xbYu++29tUGLfVBzMIhe8AF7AS7grdrgs2lli0WMmN4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)