UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '26v/St4jKnBj28dYTLpxEQ6Rk5R/fYUZ9xhZlf8akkk='
WHERE
key_id = '813ffdc6bb84ef1f9faad82b826a9d53e41833290b604a5338adaa54c9db0509'
AND (
token = '26v/St4jKnBj28dYTLpxEQ6Rk5R/fYUZ9xhZlf8akkk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)