UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7UIUy9we+mKKK8s4/X7sthqUxkezYO+gzkC+hXf46To='
WHERE
key_id = '5f378d1daa69607bcae05ade2db39cf03d9871a71670d4ebc3d2c086079fcbfe'
AND (
token = '7UIUy9we+mKKK8s4/X7sthqUxkezYO+gzkC+hXf46To='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)