UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iTu8/jOT79A47uAe05DyFyMv3nyBL9eVnr1KVhG6Cm4='
WHERE
key_id = 'd506ebd5e0537ea567ce9f5fc8d9152e31f85179c94966a84be8c494b50f8d8a'
AND (
token = 'iTu8/jOT79A47uAe05DyFyMv3nyBL9eVnr1KVhG6Cm4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)