UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lgi0uGYftS2FasHOhsR4quArdBF1dlEoaxa2S8luouE='
WHERE
key_id = '22437d77481747c222ee0c79f3228d95135b2558aae16a1f77b9167a20fa5234'
AND (
token = 'lgi0uGYftS2FasHOhsR4quArdBF1dlEoaxa2S8luouE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)