UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i2D5xB5wBJLiJutFPvDlMaaAG31cE7SVyBEntUvmWGo='
WHERE
key_id = 'f6ee39f67ac401e98318e06be647a67391974bcb52704cd8711ffacc18c3b046'
AND (
token = 'i2D5xB5wBJLiJutFPvDlMaaAG31cE7SVyBEntUvmWGo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)