UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZcYW+J+cT/cGAAddymC1HYZN8VALj2OrDwnJi0iKUac='
WHERE
key_id = '30002f4a314d9028913a04c8c81c329bad7b71254da9b8adaf6eca076725ccae'
AND (
token = 'ZcYW+J+cT/cGAAddymC1HYZN8VALj2OrDwnJi0iKUac='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)