UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P9p8EOXBp+mgQMMfvn39ICasy5bEzUg7hBg+4WcXmyA='
WHERE
key_id = '1be372b6378527e69f724264810a0bc58eb02c67010b6b7e17fd9a74ae99ee57'
AND (
token = 'P9p8EOXBp+mgQMMfvn39ICasy5bEzUg7hBg+4WcXmyA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)