UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9YfG7v/7lwK94KXEIhTRXU3f5mckPa47F9uAdn0MNVA='
WHERE
key_id = '028a117865c465cd2ec3148782c8e7fd9bc90c7ccab1aa24f15c27da68ae25e0'
AND (
token = '9YfG7v/7lwK94KXEIhTRXU3f5mckPa47F9uAdn0MNVA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)