UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+nlie64CjcKqbZuDBla67zDff48eGCx0s6byGpPgRCY='
WHERE
key_id = '4f15e7a01a76df1569a08ae91f6c1ebd16741525c4d25c88b9f12505a0414947'
AND (
token = '+nlie64CjcKqbZuDBla67zDff48eGCx0s6byGpPgRCY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)