UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1CGf4fijODaGGP8f2S0My77BdKx811Z0v36wFsJk5Nw='
WHERE
key_id = '87ad80b20de63e877bc1e6001fd4ea9277a70d8509d154a74d1517e6d8831a6f'
AND (
token = '1CGf4fijODaGGP8f2S0My77BdKx811Z0v36wFsJk5Nw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)