UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p7IiPVm6h633WkX01aFBJTnjGdti49r3vtxdliipAiM='
WHERE
key_id = 'e85a9707995c6632ecc68ee4a10883132d634946bebb86da5470e3f5bd74e31b'
AND (
token = 'p7IiPVm6h633WkX01aFBJTnjGdti49r3vtxdliipAiM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)