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