UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Or9sT7MQgr13pCUqS5Q0dNnf2sBi7bXavMASbKUePKM='
WHERE
key_id = '11c78ad5c7407e9d92d342a98495b22f11936d69cb38db93752ca13c17637ef1'
AND (
token = 'Or9sT7MQgr13pCUqS5Q0dNnf2sBi7bXavMASbKUePKM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)