UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z0tkOptZh4T8rvie330js35axjHi2mMlxz9sG6n3Kr4='
WHERE
key_id = '6c471b49ce75128a50009805434dcdb1d82937e5ca199dccbba8341d98c9e15c'
AND (
token = 'z0tkOptZh4T8rvie330js35axjHi2mMlxz9sG6n3Kr4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)