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