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