UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XOGmBUt9WUHM4hudSwkG/btpJuvdDc8Pk1w4uvapvyg='
WHERE
key_id = '32d24c91b6cdbe6b868ecae0b3bc66bfebf3775a580c8ac0fa6734457d40b470'
AND (
token = 'XOGmBUt9WUHM4hudSwkG/btpJuvdDc8Pk1w4uvapvyg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)