UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4hYk6INgUUHHDHPMvQ3IiGMANqF+ruJIL2JqTIC3zr4='
WHERE
key_id = '4678ed531468e8eeb823a3ce3ba5eae196e04d447eec0399ddcdf10223a02c11'
AND (
token = '4hYk6INgUUHHDHPMvQ3IiGMANqF+ruJIL2JqTIC3zr4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)