UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xBmOfTdSah4zGnRn+QJu6/OAOk6Uk70Jh5Q11rG+nSk='
WHERE
key_id = '1ac998e8dd9613b47b658989caac523168be7baa623fdb80aabdf74c0fd61066'
AND (
token = 'xBmOfTdSah4zGnRn+QJu6/OAOk6Uk70Jh5Q11rG+nSk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)