UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'y+67E0zgUlmEMRf4NrAXaSdEZFuwNwLIj0mPFZ2snx0='
WHERE
key_id = 'e2f40d2b425deee24d8c2c32603a9a704bf7fca2948173db84aee084eb8d8f3e'
AND (
token = 'y+67E0zgUlmEMRf4NrAXaSdEZFuwNwLIj0mPFZ2snx0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)