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