UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LPPbWPdz9ZFK3yLbiRkexgtnyUJhHMCCgLCcwjJ5qOw='
WHERE
key_id = '16cf0be6f257404602986d83c3f78d171667635cba87677cfefcc3edc8590629'
AND (
token = 'LPPbWPdz9ZFK3yLbiRkexgtnyUJhHMCCgLCcwjJ5qOw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)