UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vTn9wuIw72Dxa0rclhI0fD9dWimrQKT01uIEtyHDX/k='
WHERE
key_id = '9c24ad9a700aa58e9a13d8844ae490f4bd954525ed14d38cb26b453f1ab288ad'
AND (
token = 'vTn9wuIw72Dxa0rclhI0fD9dWimrQKT01uIEtyHDX/k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)